excel formula
This query is : Resolved
25 November 2008
If cell value *0.12 is less than 780 result shuold be actual if it is more then result is 780 how make a formula in excel
25 November 2008
=If((x*0.12)<780,y,780)
where x is variable
y is actual
where x is variable
y is actual
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Manual Rectification through AO
- IT Return filed defective u/s 139 (9)
- Fixed Deposit Claim Relinquishment by the Nominee
- Defective Return - Tds on advance
- ITR 6 Schedule CFL and UD Issues
- Not a CA , can we prepare balance sheet
- FREELANCING ACCOUNTANT
- TDS RATE ON RENT PAID TO NRI
- Income Type for interest from government bonds
- TCS ON SOFTWARE SALES
- PAYMENT TO OPEN AI AND ENVATO ELEMENT
- From 15CA for remittance by domestic travel agent by to Foreign Destination Management Company.
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
- Regarding Resignation by Auditor from Pvt. Ltd.
Trending Online Classes
CAclubindia
