O T: Spreadsheet help
"the_constructor" wrote in message o.uk...
"Steve Lupton" backwards.moc.liamg@pulevets wrote in message
...
the_constructor wrote:
Got a little problem trying to sort out a formula for a spreadsheet. Yes,
some of you may think that I should use a different group, but all the
computer groups are not as helpful as this group.
If (C23670) Then Let C31 = (C23*C27)
Hi
You don't say what to do if C23 is not less than 670. Assuming '0' for
now:-
=IIF(c23670,c23*c27,0)
IIF works like this:-
iif(something is true, put this value, otherwise put this value)
Steve
C32 is the cell which deals with KWh above 670, thus:
=(c23-670)*c29
Providing C23 = 670 .... ;-)
--
Martin
|