Forum Discussion
New to formulas - Nested If statement
Hi All,
I've read all the answers you've already given people but I can't for the life of me make this formula work. So apologies that I couldn't piece it together myself.
I need a formula that will look at what's in column C, if it's blank then the result should be blank. If it has anything in the cell, it needs to be 15% of what is in column G.
I got this part =IF(C3,isblank,0) and it works but can't figure out how to write the rest of it. Any help is appreciated.
Thanks, Christine
=IF([@[Amazon?]]="Yes",[@[Gross Sales Amt]]*0.15,0)
Hi Christine,
Could be like
=IF(ISBLANK(C3),0,0.15*G3)
Please download the attachment.
Thank you so much for your response. I appreciate it. On further looking into this data (it's for a friend) rather than having 2 columns, I have made 1 column validated to 1 of 2 values. Could you tell me what it would be for
I need column E to result in 15% of Column D If B=Amazon. If it is not Amazon then it can be blank or 0.
In trying to use the spreadsheet you sent I can't make it work, but this is actually being done a little different. Could you tell me what that formula would be? I've attached a file.
Again, thanks so much.
=IF([@[Amazon?]]="Yes",[@[Gross Sales Amt]]*0.15,0)
