Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Appreciate if anybody can help me on the below request.
B4 has a fixed amount of 50000 B6, B7, B8€¦. downwards will have various figures (ex. 50000, 40000, 35000) E6, E7, E8€¦. downwards can have 500, 250 or 0 I want a formula in f6 to check if E6 is 500 then check B6 is greater than 85% of B4 if yes E6 multiply by 2 if not 0. If E6 is 250 then check B6 is greater than 80% of B4 if yes E6 multiply by 2 if not 0. If E6 is 0 then F6 is 0. |