JimS
07-08-2010, 08:30 AM
Cannot figure how to make this formula work:
{=IF(Area="CAROLINAS",IF(Status="Completed",SUM(Margin/Revenue),"Wrong Answer"))}
The following are Range Names (all have the same number of rows):
Area
Status
Margin
Revenue
Its result is false – which is “Wrong Answer”, is should result in 14% (see the attachment).
When both the “IF” conditions match I need it to total the respective Margin and Revenue values and then divide the Margin Total by the Revenue Total.
Any help would be appreciated…
JimS
{=IF(Area="CAROLINAS",IF(Status="Completed",SUM(Margin/Revenue),"Wrong Answer"))}
The following are Range Names (all have the same number of rows):
Area
Status
Margin
Revenue
Its result is false – which is “Wrong Answer”, is should result in 14% (see the attachment).
When both the “IF” conditions match I need it to total the respective Margin and Revenue values and then divide the Margin Total by the Revenue Total.
Any help would be appreciated…
JimS