Formula for Cell Value

[rollerskate96]

The formula I need is that if another nominated cell has a value greater than 0, then this cell must = 3 or = 0 if nominated cell is 0

EG IF D18 = 0 then MY Cell = 0 or IF D18 = anything greater than 0 then MY Cell must = 3

Thanks

[Ron Coderre]

Does this work for you?

Please Login or Register  to view this content.

[rollerskate96]

Thanks Ron, Just edited my spreadsheet and YES it works OK, really was stuck on this one, so thanks again.
Pete