PDA

View Full Version : [SOLVED] formula



rjw29bs4
02-10-2019, 06:59 AM
hi help
i have this formular in
e22 =IF(C22>0,C22/1/6,".")
i also want to put another in e22 doing if d22 show a 9 then place a 0 in e22 any other number when act on
=IF(C22>0,C22/1/6,".")
please help
regards
roger

p45cal
02-10-2019, 09:52 AM
=IF(D22=9,0,IF(C22>0,C22/6,"."))