value error - if statement with ceiling function
hi experts, im having problems with an ifstatement with ceiling function (see below), it is producing a VALUE error?
basically if the range cells = zero or nothing then show nothing otherwise sum the range & roundup in increment of 0.2
basically if the range cells = zero or nothing then show nothing otherwise sum the range & roundup in increment of 0.2
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thankyou but it seems there is also a problem with h6 which should = 2.00 not 1.95,
formula is;
=IF(D6="","",F6*G6)
formula is;
=IF(D6="","",F6*G6)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thankyou experts for your solutions
ASKER
yes the ceiling formula is in each cell h6:h10
what if you trying this?
Open in new window