=if(H26=1500,if(m25=2000,0,2000),if(H26=1050,if( M25=2000,0,2000),if(H26=700,if(M25=3000,0,3000),i f(H26=525,if(M25=2000,0,2000),""))))
this leaves it blank if H26 < 525, change the "" to zero if that is your
"other" option
"cruzin" wrote:
I need to write a formla that has several conditions.
If H26=525 then a value of 2000 is entered in M26 but if M25 is 2000 then
M26 needs to be 0
AND If h26= 700 then a value of 3000 is entered in M26 but if M25 is 3000
then M26 is 0
AND If h26= 1,050 then a value of 2000 is entered in M26 but if M25 is 2000
then M26 is 0
AND If h26= 1,500 then a value of 2000 is entered in M26 but if M25 is 2000
then M26 is 0
What I am trying to do is enter a value in Column M only once - and only
when a specific number has been met.
Thanks for your help!
--
j
|