two formulas per one cell
Ok I have another issue...
I need two formulas for one cell... If H5 is <=0 then perform (E5-F5) If H5 is 0 then perform (H5-G5-E5+F5) is this possible? if so how? |
two formulas per one cell
Hi -
Try this: =IF(H5<=0,E5-F5,H5-G5-E5+F5) HTH "formula using percentage question" wrote: Ok I have another issue... I need two formulas for one cell... If H5 is <=0 then perform (E5-F5) If H5 is 0 then perform (H5-G5-E5+F5) is this possible? if so how? |
two formulas per one cell
"pdberger" wrote in message
... "formula using percentage question" wrote: Ok I have another issue... I need two formulas for one cell... If H5 is <=0 then perform (E5-F5) If H5 is 0 then perform (H5-G5-E5+F5) is this possible? if so how? Hi - Try this: =IF(H5<=0,E5-F5,H5-G5-E5+F5) But beware the circular reference. -- David Biddulph |
All times are GMT +1. The time now is 01:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com