Hello,
Sorry to bother everyone and I am sure this is probably quite straight forward but I cannot wrap my head around it
I need Excel to do the following:
If a specific word is in B6 i.e. "RENT" I would like it to do a specfic calculation in three cells (D6, E6 and F6)
I would like it to do the following
D6 =(C6/100)*41.33
E6 =(C6/100)*33.33
F6 =(C6/100)*25.34
I am hoping someone may be able to help as I cannot seem to find anything online that explains how to do this, so I am not even sure if you can.
Thanks for reading.
Bookmarks