Forum Discussion
Solved
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 th...
=IF([@[Amazon?]]="Yes",[@[Gross Sales Amt]]*0.15,0)
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)
Thank you so much. Works like a charm! Appreciate everyone who helped.