hi guys i am new here.
Please let me know what is wrong with this function i have done like it is required it seems but it does not work.
=IF(C12=30,"f12","(f12/30)*c12")
Thanks for your help.
Regards.
Oleee
hi guys i am new here.
Please let me know what is wrong with this function i have done like it is required it seems but it does not work.
=IF(C12=30,"f12","(f12/30)*c12")
Thanks for your help.
Regards.
Oleee
Last edited by oleee; 07-31-2017 at 06:08 AM.
Should be
=IF(C12=30,F12,F12/30*C12)
Dont use quotes when referring to cell references, quotes only needed for text values.
Brackets not needed since it won't change the result of the division or multiplication.
Last edited by Special-K; 07-31-2017 at 06:10 AM.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks