Nested if function

[geniusufo007]

in this example i am not using the row and column header by default in the excel but created by myself and to be solved in view of this example header not the excel default header.

SCENARIO has been mentioned inside the workbook


REQUIRED
the text mentioned in the highlighted area is actually formula but this in mentioned in the text form, i need this text in the excel formula
like if i say two plus two is equal to four in the same way the text has been mentioned like this
"Sales Tax Payable [if 17 > 25 then (17 - 25); otherwise zero] + [12 + 14b + 18 + 19 + 20 + 21 + 22 + 23 + 23a + 23b]"

[FDibbins]

"Sales Tax Payable [if 17 > 25 then (17 - 25); otherwise zero] + [12 + 14b + 18 + 19 + 20 + 21 + 22 + 23 + 23a + 23b]"

if 17 > 25 then (17 - 25)......etc
are you referring to cell references, or what?

From your file...
if 24 = Yes then 8; if 24 = No, ...
where will the YES/NO or whatever be shown?

[geniusufo007]

the cell reference i have shown on the left hand side by myself not the excel, so you may consider the reference for 24 number row i have shown in the sheet on the left hand side
in the attachment some changes have been made


it does not matter whatever the row reference in the actual excel sheet just dont consider that one consider mine one

[FDibbins]

it does not matter whatever the row reference in the actual excel sheet just dont consider that one consider mine one

actually it does matter, because excel works on cell refs, not your refs

So far I have this, but it does not agree with your answer. perhaps this will get you headed in the right direction?

=IF(F34="yes",F14,MIN(F14-F6,0.9*F23,F25))

[FDibbins]

the last part...
+ {if (8-4) < "90% of 15" then 4; otherwise zero}]

would be something like this...
=IF(F14-F6<0.9*F23,F6,0)

[geniusufo007]

yes you are right it does matter.

[geniusufo007]

now you may see the attachment, I get the answer, but for this i have to add 178,942 in F10 which is already there in my tax return, that's why we are not getting the proper answer, now i just want to confirm that the formula in cell F35 is representing the text in B35, if yes then great

second we have two more formulas in cell F36 and F42 which are to be feeded.

[geniusufo007]

Dear FDibbins please do the needful.

[AliGW]

Fdibbins is not currently online, but even if he were, you have been asked before to exercise patience.

Administrative Note:

We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - it has been only an hour since you posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

[geniusufo007]

ok sorry for inconvenience

[geniusufo007]

Dear I really appreciate your generous effort and expect for more generous effort at your end and hopefully you will not mind
i am trying with the following formula in cell F36 but there is something wrong in it
=if(f34="yes",f35>f25,(f35-f25),0),if(F34="No",(f14-f35)


the following one is showing the FALSE result
=IF(AND(F34="yes",F35>F25,(F35-F25),0),IF(F34="No",(F14-F35)))

[geniusufo007]

Dear FDibbins thank you very much for your help. I am attaching the file for your perusal after solving the example.